Profiling Report: vistaminablenormalizadaxsectores

Dataset statistics

Number of variables	28
Number of observations	91051
Missing cells	173710
Missing cells (%)	6.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	19.5 MiB
Average record size in memory	224.0 B

Variable types

Numeric	8
Categorical	16
Unsupported	4

Warnings

`tipo_persona` has constant value "Natural"	Constant
`entidad` has a high cardinality: 151 distinct values	High cardinality
`tipo_persona` is highly correlated with `genero` and 13 other fields	High correlation
`genero` is highly correlated with `tipo_persona`	High correlation
`tiene_casa_propia` is highly correlated with `tipo_persona`	High correlation
`estado_civil` is highly correlated with `tipo_persona`	High correlation
`codeudor` is highly correlated with `tipo_persona`	High correlation
`municipio_expedicion` is highly correlated with `tipo_persona` and 2 other fields	High correlation
`tipo_identificacion` is highly correlated with `tipo_persona`	High correlation
`forma_pago` is highly correlated with `tipo_persona`	High correlation
`municipio_nacimiento` is highly correlated with `tipo_persona` and 2 other fields	High correlation
`estado_final` is highly correlated with `tipo_persona`	High correlation
`tipo_venta` is highly correlated with `tipo_persona`	High correlation
`periodo_credito` is highly correlated with `tipo_persona`	High correlation
`sector` is highly correlated with `tipo_persona`	High correlation
`municipio_residencia` is highly correlated with `tipo_persona` and 2 other fields	High correlation
`municipio_credito` is highly correlated with `tipo_persona`	High correlation
`empresa` has 3993 (4.4%) missing values	Missing
`cargo` has 6016 (6.6%) missing values	Missing
`tiempo_servicio` has 17807 (19.6%) missing values	Missing
`otros_ingresos_mensual` has 69003 (75.8%) missing values	Missing
`otros_ingresos_concepto` has 76889 (84.4%) missing values	Missing
`sueldo` is highly skewed (γ1 = 55.32638512)	Skewed
`otros_ingresos_mensual` is highly skewed (γ1 = 55.03488623)	Skewed
`valor_credito` is highly skewed (γ1 = 48.65011979)	Skewed
`Row` is uniformly distributed	Uniform
`Row` has unique values	Unique
`empresa` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`cargo` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`tiempo_servicio` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`otros_ingresos_concepto` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`otros_ingresos_mensual` has 15962 (17.5%) zeros	Zeros

Reproduction

Analysis started	2021-05-05 21:32:15.968012
Analysis finished	2021-05-05 21:32:57.509141
Duration	41.54 seconds
Software version	pandas-profiling v2.12.0
Download configuration	config.yaml

Row
Real number (ℝ_≥0)

UNIFORM
UNIQUE

Distinct	91051
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	45526

Minimum	1
Maximum	91051
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	711.5 KiB

Quantile statistics

Minimum	1
5-th percentile	4553.5
Q1	22763.5
median	45526
Q3	68288.5
95-th percentile	86498.5
Maximum	91051
Range	91050
Interquartile range (IQR)	45525

Descriptive statistics

Standard deviation	26284.30402
Coefficient of variation (CV)	0.5773470987
Kurtosis	-1.2
Mean	45526
Median Absolute Deviation (MAD)	22763
Skewness	0
Sum	4145187826
Variance	690864637.7
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2047	1	< 0.1%
88702	1	< 0.1%
6806	1	< 0.1%
4759	1	< 0.1%
27288	1	< 0.1%
25241	1	< 0.1%
31386	1	< 0.1%
29339	1	< 0.1%
19100	1	< 0.1%
17053	1	< 0.1%
Other values (91041)	91041	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
91051	1	< 0.1%
91050	1	< 0.1%
91049	1	< 0.1%
91048	1	< 0.1%
91047	1	< 0.1%

tipo_identificacion
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	711.5 KiB

Cedula de Ciudadania	90731
Cedula de Extranjeria	262
Tarjeta de Identidad	23
Registro Civil	17
NIT	16

Length

Max length	21
Median length	20
Mean length	19.9985283
Min length	3

Characters and Unicode

Total characters	1820886
Distinct characters	24
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Cedula de Ciudadania
2nd row	Cedula de Ciudadania
3rd row	Cedula de Ciudadania
4th row	Cedula de Ciudadania
5th row	Cedula de Ciudadania

Value	Count	Frequency (%)
Cedula de Ciudadania	90731	99.6%
Cedula de Extranjeria	262	0.3%
Tarjeta de Identidad	23	< 0.1%
Registro Civil	17	< 0.1%
NIT	16	< 0.1%
Pasaporte	2	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
de	91016	33.3%
cedula	90993	33.3%
ciudadania	90731	33.2%
extranjeria	262	0.1%
tarjeta	23	< 0.1%
identidad	23	< 0.1%
registro	17	< 0.1%
civil	17	< 0.1%
nit	16	< 0.1%
pasaporte	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
a	363783	20.0%
d	363540	20.0%
e	182336	10.0%
	182049	10.0%
i	181798	10.0%
C	181741	10.0%
u	181724	10.0%
n	91016	5.0%
l	91010	5.0%
r	566	< 0.1%
Other values (14)	1323	0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1456721	80.0%
Uppercase Letter	182116	10.0%
Space Separator	182049	10.0%

Most frequent character per category

Value	Count	Frequency (%)
a	363783	25.0%
d	363540	25.0%
e	182336	12.5%
i	181798	12.5%
u	181724	12.5%
n	91016	6.2%
l	91010	6.2%
r	566	< 0.1%
t	327	< 0.1%
j	285	< 0.1%
Other values (6)	336	< 0.1%

Value	Count	Frequency (%)
C	181741	99.8%
E	262	0.1%
I	39	< 0.1%
T	39	< 0.1%
R	17	< 0.1%
N	16	< 0.1%
P	2	< 0.1%

Value	Count	Frequency (%)
	182049	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1638837	90.0%
Common	182049	10.0%

Most frequent character per script

Value	Count	Frequency (%)
a	363783	22.2%
d	363540	22.2%
e	182336	11.1%
i	181798	11.1%
C	181741	11.1%
u	181724	11.1%
n	91016	5.6%
l	91010	5.6%
r	566	< 0.1%
t	327	< 0.1%
Other values (13)	996	0.1%

Value	Count	Frequency (%)
	182049	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1820886	100.0%

Most frequent character per block

Value	Count	Frequency (%)
a	363783	20.0%
d	363540	20.0%
e	182336	10.0%
	182049	10.0%
i	181798	10.0%
C	181741	10.0%
u	181724	10.0%
n	91016	5.0%
l	91010	5.0%
r	566	< 0.1%
Other values (14)	1323	0.1%

genero
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	711.5 KiB

Femenino	49291
Masculino	41760

Length

Max length	9
Median length	8
Mean length	8.458644057
Min length	8

Characters and Unicode

Total characters	770168
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Femenino
2nd row	Femenino
3rd row	Femenino
4th row	Femenino
5th row	Femenino

Value	Count	Frequency (%)
Femenino	49291	54.1%
Masculino	41760	45.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
femenino	49291	54.1%
masculino	41760	45.9%

Most occurring characters

Value	Count	Frequency (%)
n	140342	18.2%
e	98582	12.8%
i	91051	11.8%
o	91051	11.8%
F	49291	6.4%
m	49291	6.4%
M	41760	5.4%
a	41760	5.4%
s	41760	5.4%
c	41760	5.4%
Other values (2)	83520	10.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	679117	88.2%
Uppercase Letter	91051	11.8%

Most frequent character per category

Value	Count	Frequency (%)
n	140342	20.7%
e	98582	14.5%
i	91051	13.4%
o	91051	13.4%
m	49291	7.3%
a	41760	6.1%
s	41760	6.1%
c	41760	6.1%
u	41760	6.1%
l	41760	6.1%

Value	Count	Frequency (%)
F	49291	54.1%
M	41760	45.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	770168	100.0%

Most frequent character per script

Value	Count	Frequency (%)
n	140342	18.2%
e	98582	12.8%
i	91051	11.8%
o	91051	11.8%
F	49291	6.4%
m	49291	6.4%
M	41760	5.4%
a	41760	5.4%
s	41760	5.4%
c	41760	5.4%
Other values (2)	83520	10.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	770168	100.0%

Most frequent character per block

Value	Count	Frequency (%)
n	140342	18.2%
e	98582	12.8%
i	91051	11.8%
o	91051	11.8%
F	49291	6.4%
m	49291	6.4%
M	41760	5.4%
a	41760	5.4%
s	41760	5.4%
c	41760	5.4%
Other values (2)	83520	10.8%

estado_civil
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	711.5 KiB

Union Libre	34793
Casado	27735
Soltero	27101
Viudo	862
Divorciado	560

Length

Max length	11
Median length	7
Mean length	8.223413252
Min length	5

Characters and Unicode

Total characters	748750
Distinct characters	21
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Soltero
2nd row	Union Libre
3rd row	Union Libre
4th row	Casado
5th row	Soltero

Value	Count	Frequency (%)
Union Libre	34793	38.2%
Casado	27735	30.5%
Soltero	27101	29.8%
Viudo	862	0.9%
Divorciado	560	0.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
libre	34793	27.6%
union	34793	27.6%
casado	27735	22.0%
soltero	27101	21.5%
viudo	862	0.7%
divorciado	560	0.4%

Most occurring characters

Value	Count	Frequency (%)
o	118712	15.9%
i	71568	9.6%
n	69586	9.3%
r	62454	8.3%
e	61894	8.3%
a	56030	7.5%
U	34793	4.6%
	34793	4.6%
L	34793	4.6%
b	34793	4.6%
Other values (11)	169334	22.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	588113	78.5%
Uppercase Letter	125844	16.8%
Space Separator	34793	4.6%

Most frequent character per category

Value	Count	Frequency (%)
o	118712	20.2%
i	71568	12.2%
n	69586	11.8%
r	62454	10.6%
e	61894	10.5%
a	56030	9.5%
b	34793	5.9%
d	29157	5.0%
s	27735	4.7%
l	27101	4.6%
Other values (4)	29083	4.9%

Value	Count	Frequency (%)
U	34793	27.6%
L	34793	27.6%
C	27735	22.0%
S	27101	21.5%
V	862	0.7%
D	560	0.4%

Value	Count	Frequency (%)
	34793	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	713957	95.4%
Common	34793	4.6%

Most frequent character per script

Value	Count	Frequency (%)
o	118712	16.6%
i	71568	10.0%
n	69586	9.7%
r	62454	8.7%
e	61894	8.7%
a	56030	7.8%
U	34793	4.9%
L	34793	4.9%
b	34793	4.9%
d	29157	4.1%
Other values (10)	140177	19.6%

Value	Count	Frequency (%)
	34793	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	748750	100.0%

Most frequent character per block

Value	Count	Frequency (%)
o	118712	15.9%
i	71568	9.6%
n	69586	9.3%
r	62454	8.3%
e	61894	8.3%
a	56030	7.5%
U	34793	4.6%
	34793	4.6%
L	34793	4.6%
b	34793	4.6%
Other values (11)	169334	22.6%

edad
Real number (ℝ_≥0)

Distinct	73
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44.11897728

Minimum	18
Maximum	98
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	711.5 KiB

Quantile statistics

Minimum	18
5-th percentile	26
Q1	35
median	43
Q3	52
95-th percentile	64
Maximum	98
Range	80
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	11.92193633
Coefficient of variation (CV)	0.2702224092
Kurtosis	-0.3788885876
Mean	44.11897728
Median Absolute Deviation (MAD)	9
Skewness	0.3402068718
Sum	4017077
Variance	142.1325658
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
44	3404	3.7%
40	3167	3.5%
41	2933	3.2%
45	2857	3.1%
35	2814	3.1%
49	2752	3.0%
46	2687	3.0%
36	2646	2.9%
31	2597	2.9%
39	2567	2.8%
Other values (63)	62627	68.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
18	12	< 0.1%
19	66	0.1%
20	214	0.2%
21	292	0.3%
22	459	0.5%

Value	Count	Frequency (%)
98	2	< 0.1%
90	3	< 0.1%
89	1	< 0.1%
88	2	< 0.1%
87	1	< 0.1%

municipio_residencia
Categorical

HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	711.5 KiB

ARAUCA	39509
TAME	24617
ARAUQUITA	9258
PUERTO RONDON	4662
SARAVENA	4288
Other values (22)	8717

Length

Max length	14
Median length	6
Mean length	6.560235472
Min length	4

Characters and Unicode

Total characters	597316
Distinct characters	26
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	ARAUCA
2nd row	ARAUCA
3rd row	ARAUCA
4th row	ARAUCA
5th row	ARAUCA

Value	Count	Frequency (%)
ARAUCA	39509	43.4%
TAME	24617	27.0%
ARAUQUITA	9258	10.2%
PUERTO RONDON	4662	5.1%
SARAVENA	4288	4.7%
PUERTO JORDAN	4161	4.6%
FORTUL	3653	4.0%
PANAMA	335	0.4%
HATO COROZAL	213	0.2%
CRAVO NORTE	148	0.2%
Other values (17)	207	0.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
arauca	39509	39.4%
tame	24617	24.6%
arauquita	9258	9.2%
puerto	8823	8.8%
rondon	4662	4.7%
saravena	4288	4.3%
jordan	4161	4.2%
fortul	3653	3.6%
panama	335	0.3%
hato	213	0.2%
Other values (24)	726	0.7%

Most occurring characters

Value	Count	Frequency (%)
A	189904	31.8%
R	74983	12.6%
U	70629	11.8%
T	46750	7.8%
C	40043	6.7%
E	37930	6.4%
O	26928	4.5%
M	24997	4.2%
N	18280	3.1%
I	9312	1.6%
Other values (16)	57560	9.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	588121	98.5%
Space Separator	9194	1.5%
Other Punctuation	1	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
A	189904	32.3%
R	74983	12.7%
U	70629	12.0%
T	46750	7.9%
C	40043	6.8%
E	37930	6.4%
O	26928	4.6%
M	24997	4.3%
N	18280	3.1%
I	9312	1.6%
Other values (14)	48365	8.2%

Value	Count	Frequency (%)
	9194	100.0%

Value	Count	Frequency (%)
.	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	588121	98.5%
Common	9195	1.5%

Most frequent character per script

Value	Count	Frequency (%)
A	189904	32.3%
R	74983	12.7%
U	70629	12.0%
T	46750	7.9%
C	40043	6.8%
E	37930	6.4%
O	26928	4.6%
M	24997	4.3%
N	18280	3.1%
I	9312	1.6%
Other values (14)	48365	8.2%

Value	Count	Frequency (%)
	9194	> 99.9%
.	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	597315	> 99.9%
None	1	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
A	189904	31.8%
R	74983	12.6%
U	70629	11.8%
T	46750	7.8%
C	40043	6.7%
E	37930	6.4%
O	26928	4.5%
M	24997	4.2%
N	18280	3.1%
I	9312	1.6%
Other values (15)	57559	9.6%

Value	Count	Frequency (%)
Á	1	100.0%

tipo_persona
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	711.5 KiB

Natural	91051

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	637357
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Natural
2nd row	Natural
3rd row	Natural
4th row	Natural
5th row	Natural

Value	Count	Frequency (%)
Natural	91051	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
natural	91051	100.0%

Most occurring characters

Value	Count	Frequency (%)
a	182102	28.6%
N	91051	14.3%
t	91051	14.3%
u	91051	14.3%
r	91051	14.3%
l	91051	14.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	546306	85.7%
Uppercase Letter	91051	14.3%

Most frequent character per category

Value	Count	Frequency (%)
a	182102	33.3%
t	91051	16.7%
u	91051	16.7%
r	91051	16.7%
l	91051	16.7%

Value	Count	Frequency (%)
N	91051	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	637357	100.0%

Most frequent character per script

Value	Count	Frequency (%)
a	182102	28.6%
N	91051	14.3%
t	91051	14.3%
u	91051	14.3%
r	91051	14.3%
l	91051	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	637357	100.0%

Most frequent character per block

Value	Count	Frequency (%)
a	182102	28.6%
N	91051	14.3%
t	91051	14.3%
u	91051	14.3%
r	91051	14.3%
l	91051	14.3%

empresa
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	3993
Missing (%)	4.4%
Memory size	711.5 KiB

municipio_nacimiento
Categorical

HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	711.5 KiB

ARAUCA	39509
TAME	24617
ARAUQUITA	9258
PUERTO RONDON	4662
SARAVENA	4288
Other values (22)	8717

Length

Max length	14
Median length	6
Mean length	6.560235472
Min length	4

Characters and Unicode

Total characters	597316
Distinct characters	26
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	ARAUCA
2nd row	ARAUCA
3rd row	ARAUCA
4th row	ARAUCA
5th row	ARAUCA

Value	Count	Frequency (%)
ARAUCA	39509	43.4%
TAME	24617	27.0%
ARAUQUITA	9258	10.2%
PUERTO RONDON	4662	5.1%
SARAVENA	4288	4.7%
PUERTO JORDAN	4161	4.6%
FORTUL	3653	4.0%
PANAMA	335	0.4%
HATO COROZAL	213	0.2%
CRAVO NORTE	148	0.2%
Other values (17)	207	0.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
arauca	39509	39.4%
tame	24617	24.6%
arauquita	9258	9.2%
puerto	8823	8.8%
rondon	4662	4.7%
saravena	4288	4.3%
jordan	4161	4.2%
fortul	3653	3.6%
panama	335	0.3%
hato	213	0.2%
Other values (24)	726	0.7%

Most occurring characters

Value	Count	Frequency (%)
A	189904	31.8%
R	74983	12.6%
U	70629	11.8%
T	46750	7.8%
C	40043	6.7%
E	37930	6.4%
O	26928	4.5%
M	24997	4.2%
N	18280	3.1%
I	9312	1.6%
Other values (16)	57560	9.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	588121	98.5%
Space Separator	9194	1.5%
Other Punctuation	1	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
A	189904	32.3%
R	74983	12.7%
U	70629	12.0%
T	46750	7.9%
C	40043	6.8%
E	37930	6.4%
O	26928	4.6%
M	24997	4.3%
N	18280	3.1%
I	9312	1.6%
Other values (14)	48365	8.2%

Value	Count	Frequency (%)
	9194	100.0%

Value	Count	Frequency (%)
.	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	588121	98.5%
Common	9195	1.5%

Most frequent character per script

Value	Count	Frequency (%)
A	189904	32.3%
R	74983	12.7%
U	70629	12.0%
T	46750	7.9%
C	40043	6.8%
E	37930	6.4%
O	26928	4.6%
M	24997	4.3%
N	18280	3.1%
I	9312	1.6%
Other values (14)	48365	8.2%

Value	Count	Frequency (%)
	9194	> 99.9%
.	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	597315	> 99.9%
None	1	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
A	189904	31.8%
R	74983	12.6%
U	70629	11.8%
T	46750	7.8%
C	40043	6.7%
E	37930	6.4%
O	26928	4.5%
M	24997	4.2%
N	18280	3.1%
I	9312	1.6%
Other values (15)	57559	9.6%

Value	Count	Frequency (%)
Á	1	100.0%

municipio_expedicion
Categorical

HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	711.5 KiB

ARAUCA	39509
TAME	24617
ARAUQUITA	9258
PUERTO RONDON	4662
SARAVENA	4288
Other values (22)	8717

Length

Max length	14
Median length	6
Mean length	6.560235472
Min length	4

Characters and Unicode

Total characters	597316
Distinct characters	26
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	ARAUCA
2nd row	ARAUCA
3rd row	ARAUCA
4th row	ARAUCA
5th row	ARAUCA

Value	Count	Frequency (%)
ARAUCA	39509	43.4%
TAME	24617	27.0%
ARAUQUITA	9258	10.2%
PUERTO RONDON	4662	5.1%
SARAVENA	4288	4.7%
PUERTO JORDAN	4161	4.6%
FORTUL	3653	4.0%
PANAMA	335	0.4%
HATO COROZAL	213	0.2%
CRAVO NORTE	148	0.2%
Other values (17)	207	0.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
arauca	39509	39.4%
tame	24617	24.6%
arauquita	9258	9.2%
puerto	8823	8.8%
rondon	4662	4.7%
saravena	4288	4.3%
jordan	4161	4.2%
fortul	3653	3.6%
panama	335	0.3%
hato	213	0.2%
Other values (24)	726	0.7%

Most occurring characters

Value	Count	Frequency (%)
A	189904	31.8%
R	74983	12.6%
U	70629	11.8%
T	46750	7.8%
C	40043	6.7%
E	37930	6.4%
O	26928	4.5%
M	24997	4.2%
N	18280	3.1%
I	9312	1.6%
Other values (16)	57560	9.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	588121	98.5%
Space Separator	9194	1.5%
Other Punctuation	1	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
A	189904	32.3%
R	74983	12.7%
U	70629	12.0%
T	46750	7.9%
C	40043	6.8%
E	37930	6.4%
O	26928	4.6%
M	24997	4.3%
N	18280	3.1%
I	9312	1.6%
Other values (14)	48365	8.2%

Value	Count	Frequency (%)
	9194	100.0%

Value	Count	Frequency (%)
.	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	588121	98.5%
Common	9195	1.5%

Most frequent character per script

Value	Count	Frequency (%)
A	189904	32.3%
R	74983	12.7%
U	70629	12.0%
T	46750	7.9%
C	40043	6.8%
E	37930	6.4%
O	26928	4.6%
M	24997	4.3%
N	18280	3.1%
I	9312	1.6%
Other values (14)	48365	8.2%

Value	Count	Frequency (%)
	9194	> 99.9%
.	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	597315	> 99.9%
None	1	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
A	189904	31.8%
R	74983	12.6%
U	70629	11.8%
T	46750	7.8%
C	40043	6.7%
E	37930	6.4%
O	26928	4.5%
M	24997	4.2%
N	18280	3.1%
I	9312	1.6%
Other values (15)	57559	9.6%

Value	Count	Frequency (%)
Á	1	100.0%

tiene_casa_propia
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	711.5 KiB

Si	64707
No	26344

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	182102
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Si
2nd row	No
3rd row	No
4th row	Si
5th row	Si

Value	Count	Frequency (%)
Si	64707	71.1%
No	26344	28.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
si	64707	71.1%
no	26344	28.9%

Most occurring characters

Value	Count	Frequency (%)
S	64707	35.5%
i	64707	35.5%
N	26344	14.5%
o	26344	14.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	91051	50.0%
Lowercase Letter	91051	50.0%

Most frequent character per category

Value	Count	Frequency (%)
S	64707	71.1%
N	26344	28.9%

Value	Count	Frequency (%)
i	64707	71.1%
o	26344	28.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	182102	100.0%

Most frequent character per script

Value	Count	Frequency (%)
S	64707	35.5%
i	64707	35.5%
N	26344	14.5%
o	26344	14.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	182102	100.0%

Most frequent character per block

Value	Count	Frequency (%)
S	64707	35.5%
i	64707	35.5%
N	26344	14.5%
o	26344	14.5%

cargo
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	6016
Missing (%)	6.6%
Memory size	711.5 KiB

sueldo
Real number (ℝ_≥0)

SKEWED

Distinct	683
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2859056.528

Minimum	0
Maximum	3204740882
Zeros	356
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	711.5 KiB

Quantile statistics

Minimum	0
5-th percentile	700000
Q1	908526
median	1500000
Q3	2500000
95-th percentile	4500000
Maximum	3204740882
Range	3204740882
Interquartile range (IQR)	1591474

Descriptive statistics

Standard deviation	46992377.74
Coefficient of variation (CV)	16.43632341
Kurtosis	3260.557737
Mean	2859056.528
Median Absolute Deviation (MAD)	591474
Skewness	55.32638512
Sum	2.603199559 × 10¹¹
Variance	2.208283565 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
908526	11022	12.1%
2000000	9250	10.2%
1000000	7714	8.5%
1500000	6764	7.4%
1200000	5502	6.0%
3000000	4903	5.4%
800000	3043	3.3%
4000000	2992	3.3%
1800000	2854	3.1%
2500000	2744	3.0%
Other values (673)	34263	37.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	356	0.4%
152	131	0.1%
800	2	< 0.1%
30000	1	< 0.1%
93000	1	< 0.1%

Value	Count	Frequency (%)
3204740882	3	< 0.1%
3203428840	2	< 0.1%
3174339461	3	< 0.1%
3016878081	4	< 0.1%
2000000000	16	< 0.1%

tiempo_servicio
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	17807
Missing (%)	19.6%
Memory size	711.5 KiB

otros_ingresos_mensual
Real number (ℝ_≥0)

MISSING
SKEWED
ZEROS

Distinct	96
Distinct (%)	0.4%
Missing	69003
Missing (%)	75.8%
Infinite	0
Infinite (%)	0.0%
Mean	1421263.051

Minimum	0
Maximum	3143089323
Zeros	15962
Zeros (%)	17.5%
Negative	0
Negative (%)	0.0%
Memory size	711.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	300000
95-th percentile	2000000
Maximum	3143089323
Range	3143089323
Interquartile range (IQR)	300000

Descriptive statistics

Standard deviation	56019916.75
Coefficient of variation (CV)	39.41558652
Kurtosis	3051.499426
Mean	1421263.051
Median Absolute Deviation (MAD)	0
Skewness	55.03488623
Sum	3.133600775 × 10¹⁰
Variance	3.138231073 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	15962	17.5%
1000000	894	1.0%
500000	706	0.8%
400000	506	0.6%
600000	423	0.5%
2000000	388	0.4%
800000	337	0.4%
200000	319	0.4%
300000	279	0.3%
1500000	234	0.3%
Other values (86)	2000	2.2%
(Missing)	69003	75.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	15962	17.5%
50000	3	< 0.1%
80000	2	< 0.1%
100000	79	0.1%
120000	7	< 0.1%

Value	Count	Frequency (%)
3143089323	1	< 0.1%
3118534287	2	< 0.1%
3114770734	4	< 0.1%
1000000000	1	< 0.1%
60000000	18	< 0.1%

otros_ingresos_concepto
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	76889
Missing (%)	84.4%
Memory size	711.5 KiB

municipio_credito
Categorical

HIGH CORRELATION

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	711.5 KiB

ARAUCA	40815
TAME	25122
ARAUQUITA	8799
SARAVENA	5845
PUERTO RONDON	3691
Other values (4)	6779

Length

Max length	13
Median length	6
Mean length	6.43173606
Min length	4

Characters and Unicode

Total characters	585616
Distinct characters	19
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ARAUCA
2nd row	ARAUCA
3rd row	ARAUCA
4th row	ARAUCA
5th row	ARAUCA

Value	Count	Frequency (%)
ARAUCA	40815	44.8%
TAME	25122	27.6%
ARAUQUITA	8799	9.7%
SARAVENA	5845	6.4%
PUERTO RONDON	3691	4.1%
PUERTO JORDAN	3660	4.0%
FORTUL	3066	3.4%
PANAMA	51	0.1%
CRAVO NORTE	2	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
arauca	40815	41.5%
tame	25122	25.5%
arauquita	8799	8.9%
puerto	7351	7.5%
saravena	5845	5.9%
rondon	3691	3.8%
jordan	3660	3.7%
fortul	3066	3.1%
panama	51	0.1%
norte	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	195314	33.4%
R	73231	12.5%
U	68830	11.8%
T	44340	7.6%
C	40817	7.0%
E	38320	6.5%
M	25173	4.3%
O	21463	3.7%
N	16940	2.9%
Q	8799	1.5%
Other values (9)	52389	8.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	578263	98.7%
Space Separator	7353	1.3%

Most frequent character per category

Value	Count	Frequency (%)
A	195314	33.8%
R	73231	12.7%
U	68830	11.9%
T	44340	7.7%
C	40817	7.1%
E	38320	6.6%
M	25173	4.4%
O	21463	3.7%
N	16940	2.9%
Q	8799	1.5%
Other values (8)	45036	7.8%

Value	Count	Frequency (%)
	7353	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	578263	98.7%
Common	7353	1.3%

Most frequent character per script

Value	Count	Frequency (%)
A	195314	33.8%
R	73231	12.7%
U	68830	11.9%
T	44340	7.7%
C	40817	7.1%
E	38320	6.6%
M	25173	4.4%
O	21463	3.7%
N	16940	2.9%
Q	8799	1.5%
Other values (8)	45036	7.8%

Value	Count	Frequency (%)
	7353	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	585616	100.0%

Most frequent character per block

Value	Count	Frequency (%)
A	195314	33.4%
R	73231	12.5%
U	68830	11.8%
T	44340	7.6%
C	40817	7.0%
E	38320	6.5%
M	25173	4.3%
O	21463	3.7%
N	16940	2.9%
Q	8799	1.5%
Other values (9)	52389	8.9%

codeudor
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	711.5 KiB

SIN CODEUDOR	80127
CON CODEUDOR	10924

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	1092612
Distinct characters	10
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SIN CODEUDOR
2nd row	SIN CODEUDOR
3rd row	SIN CODEUDOR
4th row	SIN CODEUDOR
5th row	SIN CODEUDOR

Value	Count	Frequency (%)
SIN CODEUDOR	80127	88.0%
CON CODEUDOR	10924	12.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
codeudor	91051	50.0%
sin	80127	44.0%
con	10924	6.0%

Most occurring characters

Value	Count	Frequency (%)
O	193026	17.7%
D	182102	16.7%
C	101975	9.3%
N	91051	8.3%
	91051	8.3%
E	91051	8.3%
U	91051	8.3%
R	91051	8.3%
S	80127	7.3%
I	80127	7.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1001561	91.7%
Space Separator	91051	8.3%

Most frequent character per category

Value	Count	Frequency (%)
O	193026	19.3%
D	182102	18.2%
C	101975	10.2%
N	91051	9.1%
E	91051	9.1%
U	91051	9.1%
R	91051	9.1%
S	80127	8.0%
I	80127	8.0%

Value	Count	Frequency (%)
	91051	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1001561	91.7%
Common	91051	8.3%

Most frequent character per script

Value	Count	Frequency (%)
O	193026	19.3%
D	182102	18.2%
C	101975	10.2%
N	91051	9.1%
E	91051	9.1%
U	91051	9.1%
R	91051	9.1%
S	80127	8.0%
I	80127	8.0%

Value	Count	Frequency (%)
	91051	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1092612	100.0%

Most frequent character per block

Value	Count	Frequency (%)
O	193026	17.7%
D	182102	16.7%
C	101975	9.3%
N	91051	8.3%
	91051	8.3%
E	91051	8.3%
U	91051	8.3%
R	91051	8.3%
S	80127	7.3%
I	80127	7.3%

entidad
Categorical

HIGH CARDINALITY

Distinct	151
Distinct (%)	0.2%
Missing	1
Missing (%)	< 0.1%
Memory size	711.5 KiB

INDEPENDIENTES ARAUCA	20352
CONTADO	11306
CREDITOS TAME	11002
CONTADOS DE TAME	8120
INDEP. ARAUQUITA	5015
Other values (146)	35255

Length

Max length	35
Median length	16
Mean length	15.8190335
Min length	6

Characters and Unicode

Total characters	1440323
Distinct characters	44
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	15 ?
Unique (%)	< 0.1%

Sample

1st row	ALCALDIA DE ARAUCA
2nd row	ALCALDIA DE ARAUCA
3rd row	ALCALDIA DE ARAUCA
4th row	ALCALDIA DE ARAUCA
5th row	ALCALDIA DE ARAUCA

Value	Count	Frequency (%)
INDEPENDIENTES ARAUCA	20352	22.4%
CONTADO	11306	12.4%
CREDITOS TAME	11002	12.1%
CONTADOS DE TAME	8120	8.9%
INDEP. ARAUQUITA	5015	5.5%
PUEBLO NUEVO	3068	3.4%
FORTUL	2950	3.2%
CONTADOS ARAUQUITA	2919	3.2%
PUERTO RONDON	2896	3.2%
FONDO EDUCATIVO REGIONAL	2584	2.8%
Other values (141)	20838	22.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
arauca	24020	12.8%
tame	22836	12.2%
independientes	22644	12.1%
de	15005	8.0%
contados	13476	7.2%
creditos	11753	6.3%
contado	11306	6.0%
arauquita	8721	4.6%
indep	5015	2.7%
saravena	4858	2.6%
Other values (179)	48272	25.7%

Most occurring characters

Value	Count	Frequency (%)
A	188987	13.1%
E	178025	12.4%
N	126058	8.8%
D	118287	8.2%
O	114624	8.0%
T	111907	7.8%
	96893	6.7%
I	92010	6.4%
R	73792	5.1%
C	70973	4.9%
Other values (34)	268767	18.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1330412	92.4%
Space Separator	96893	6.7%
Other Punctuation	10181	0.7%
Dash Punctuation	1022	0.1%
Open Punctuation	881	0.1%
Close Punctuation	859	0.1%
Lowercase Letter	57	< 0.1%
Decimal Number	18	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
A	188987	14.2%
E	178025	13.4%
N	126058	9.5%
D	118287	8.9%
O	114624	8.6%
T	111907	8.4%
I	92010	6.9%
R	73792	5.5%
C	70973	5.3%
S	69158	5.2%
Other values (18)	186591	14.0%

Value	Count	Frequency (%)
o	22	38.6%
a	15	26.3%
r	5	8.8%
v	5	8.8%
e	5	8.8%
n	5	8.8%

Value	Count	Frequency (%)
.	8285	81.4%
,	1185	11.6%
"	702	6.9%
%	9	0.1%

Value	Count	Frequency (%)
6	9	50.0%
0	9	50.0%

Value	Count	Frequency (%)
	96893	100.0%

Value	Count	Frequency (%)
(	881	100.0%

Value	Count	Frequency (%)
)	859	100.0%

Value	Count	Frequency (%)
-	1022	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1330469	92.4%
Common	109854	7.6%

Most frequent character per script

Value	Count	Frequency (%)
A	188987	14.2%
E	178025	13.4%
N	126058	9.5%
D	118287	8.9%
O	114624	8.6%
T	111907	8.4%
I	92010	6.9%
R	73792	5.5%
C	70973	5.3%
S	69158	5.2%
Other values (24)	186648	14.0%

Value	Count	Frequency (%)
	96893	88.2%
.	8285	7.5%
,	1185	1.1%
-	1022	0.9%
(	881	0.8%
)	859	0.8%
"	702	0.6%
6	9	< 0.1%
0	9	< 0.1%
%	9	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1440082	> 99.9%
None	241	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
A	188987	13.1%
E	178025	12.4%
N	126058	8.8%
D	118287	8.2%
O	114624	8.0%
T	111907	7.8%
	96893	6.7%
I	92010	6.4%
R	73792	5.1%
C	70973	4.9%
Other values (32)	268526	18.6%

Value	Count	Frequency (%)
Ñ	205	85.1%
Á	36	14.9%

sector
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	711.5 KiB

PRIVADO	84054
PUBLICO	6996

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	637350
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PUBLICO
2nd row	PUBLICO
3rd row	PUBLICO
4th row	PUBLICO
5th row	PUBLICO

Value	Count	Frequency (%)
PRIVADO	84054	92.3%
PUBLICO	6996	7.7%
(Missing)	1	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
privado	84054	92.3%
publico	6996	7.7%

Most occurring characters

Value	Count	Frequency (%)
P	91050	14.3%
I	91050	14.3%
O	91050	14.3%
R	84054	13.2%
V	84054	13.2%
A	84054	13.2%
D	84054	13.2%
U	6996	1.1%
B	6996	1.1%
L	6996	1.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	637350	100.0%

Most frequent character per category

Value	Count	Frequency (%)
P	91050	14.3%
I	91050	14.3%
O	91050	14.3%
R	84054	13.2%
V	84054	13.2%
A	84054	13.2%
D	84054	13.2%
U	6996	1.1%
B	6996	1.1%
L	6996	1.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	637350	100.0%

Most frequent character per script

Value	Count	Frequency (%)
P	91050	14.3%
I	91050	14.3%
O	91050	14.3%
R	84054	13.2%
V	84054	13.2%
A	84054	13.2%
D	84054	13.2%
U	6996	1.1%
B	6996	1.1%
L	6996	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	637350	100.0%

Most frequent character per block

Value	Count	Frequency (%)
P	91050	14.3%
I	91050	14.3%
O	91050	14.3%
R	84054	13.2%
V	84054	13.2%
A	84054	13.2%
D	84054	13.2%
U	6996	1.1%
B	6996	1.1%
L	6996	1.1%

año_credito
Real number (ℝ_≥0)

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2014.573865

Minimum	1993
Maximum	2021
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	711.5 KiB

Quantile statistics

Minimum	1993
5-th percentile	2004
Q1	2012
median	2016
Q3	2019
95-th percentile	2020
Maximum	2021
Range	28
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	5.234167277
Coefficient of variation (CV)	0.002598151086
Kurtosis	0.5839776732
Mean	2014.573865
Median Absolute Deviation (MAD)	3
Skewness	-1.068504403
Sum	183428965
Variance	27.39650708
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
2020	12917	14.2%
2019	12395	13.6%
2018	7489	8.2%
2015	7059	7.8%
2017	6514	7.2%
2016	5967	6.6%
2014	5513	6.1%
2013	4956	5.4%
2012	4464	4.9%
2011	3847	4.2%
Other values (16)	19930	21.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1993	1	< 0.1%
1997	206	0.2%
1998	404	0.4%
1999	514	0.6%
2000	597	0.7%

Value	Count	Frequency (%)
2021	2020	2.2%
2020	12917	14.2%
2019	12395	13.6%
2018	7489	8.2%
2017	6514	7.2%

mes_credito
Real number (ℝ_≥0)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.831061713

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	711.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.481223489
Coefficient of variation (CV)	0.509616753
Kurtosis	-1.218913564
Mean	6.831061713
Median Absolute Deviation (MAD)	3
Skewness	-0.1088082783
Sum	621975
Variance	12.11891698
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
12	9588	10.5%
10	8806	9.7%
11	7989	8.8%
9	7860	8.6%
7	7722	8.5%
6	7512	8.3%
5	7443	8.2%
8	7060	7.8%
3	7048	7.7%
2	6932	7.6%
Other values (2)	13091	14.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	6651	7.3%
2	6932	7.6%
3	7048	7.7%
4	6440	7.1%
5	7443	8.2%

Value	Count	Frequency (%)
12	9588	10.5%
11	7989	8.8%
10	8806	9.7%
9	7860	8.6%
8	7060	7.8%

valor_credito
Real number (ℝ_≥0)

SKEWED

Distinct	6710
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1292388.962

Minimum	1
Maximum	299250000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	711.5 KiB

Quantile statistics

Minimum	1
5-th percentile	60000
Q1	350000
median	882000
Q3	1570000
95-th percentile	4215500
Maximum	299250000
Range	299249999
Interquartile range (IQR)	1220000

Descriptive statistics

Standard deviation	1982049.202
Coefficient of variation (CV)	1.533632103
Kurtosis	6433.666994
Mean	1292388.962
Median Absolute Deviation (MAD)	592000
Skewness	48.65011979
Sum	1.176733074 × 10¹¹
Variance	3.928519038 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100000	669	0.7%
160000	641	0.7%
200000	633	0.7%
1200000	628	0.7%
180000	623	0.7%
1000000	614	0.7%
130000	598	0.7%
50000	595	0.7%
400000	551	0.6%
600000	546	0.6%
Other values (6700)	84953	93.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
1000	6	< 0.1%
1250	1	< 0.1%
1300	1	< 0.1%
1500	1	< 0.1%

Value	Count	Frequency (%)
299250000	1	< 0.1%
183719000	1	< 0.1%
75160000	1	< 0.1%
41862000	1	< 0.1%
40784000	1	< 0.1%

estado_final
Categorical

HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	711.5 KiB

PAGADO VENCIDO	38860
PAGADO ANTICIPADO	20290
CONTADO	19524
PAGADO A TIEMPO	5990
DESCUENTO EN VENTA	5342
Other values (3)	1045

Length

Max length	18
Median length	14
Mean length	13.4552833
Min length	7

Characters and Unicode

Total characters	1225117
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PAGADO VENCIDO
2nd row	PAGADO VENCIDO
3rd row	PAGADO VENCIDO
4th row	PAGADO VENCIDO
5th row	PAGADO VENCIDO

Value	Count	Frequency (%)
PAGADO VENCIDO	38860	42.7%
PAGADO ANTICIPADO	20290	22.3%
CONTADO	19524	21.4%
PAGADO A TIEMPO	5990	6.6%
DESCUENTO EN VENTA	5342	5.9%
DEVOLUCION	528	0.6%
CARTERA CASTIGADA	368	0.4%
OTROS CIERRES	149	0.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
pagado	65140	37.6%
vencido	38860	22.4%
anticipado	20290	11.7%
contado	19524	11.3%
tiempo	5990	3.5%
a	5990	3.5%
venta	5342	3.1%
descuento	5342	3.1%
en	5342	3.1%
devolucion	528	0.3%
Other values (4)	1034	0.6%

Most occurring characters

Value	Count	Frequency (%)
A	203556	16.6%
O	176024	14.4%
D	150052	12.2%
N	95228	7.8%
P	91420	7.5%
I	86475	7.1%
C	85429	7.0%
	82331	6.7%
E	67412	5.5%
G	65508	5.3%
Other values (7)	121682	9.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1142786	93.3%
Space Separator	82331	6.7%

Most frequent character per category

Value	Count	Frequency (%)
A	203556	17.8%
O	176024	15.4%
D	150052	13.1%
N	95228	8.3%
P	91420	8.0%
I	86475	7.6%
C	85429	7.5%
E	67412	5.9%
G	65508	5.7%
T	57373	5.0%
Other values (6)	64309	5.6%

Value	Count	Frequency (%)
	82331	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1142786	93.3%
Common	82331	6.7%

Most frequent character per script

Value	Count	Frequency (%)
A	203556	17.8%
O	176024	15.4%
D	150052	13.1%
N	95228	8.3%
P	91420	8.0%
I	86475	7.6%
C	85429	7.5%
E	67412	5.9%
G	65508	5.7%
T	57373	5.0%
Other values (6)	64309	5.6%

Value	Count	Frequency (%)
	82331	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1225117	100.0%

Most frequent character per block

Value	Count	Frequency (%)
A	203556	16.6%
O	176024	14.4%
D	150052	12.2%
N	95228	7.8%
P	91420	7.5%
I	86475	7.1%
C	85429	7.0%
	82331	6.7%
E	67412	5.5%
G	65508	5.3%
Other values (7)	121682	9.9%

tipo_venta
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	711.5 KiB

ELECTRODOMESTICOS	90240
MOTOS	811

Length

Max length	17
Median length	17
Mean length	16.89311485
Min length	5

Characters and Unicode

Total characters	1538135
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ELECTRODOMESTICOS
2nd row	ELECTRODOMESTICOS
3rd row	ELECTRODOMESTICOS
4th row	ELECTRODOMESTICOS
5th row	ELECTRODOMESTICOS

Value	Count	Frequency (%)
ELECTRODOMESTICOS	90240	99.1%
MOTOS	811	0.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
electrodomesticos	90240	99.1%
motos	811	0.9%

Most occurring characters

Value	Count	Frequency (%)
O	272342	17.7%
E	270720	17.6%
T	181291	11.8%
S	181291	11.8%
C	180480	11.7%
M	91051	5.9%
L	90240	5.9%
R	90240	5.9%
D	90240	5.9%
I	90240	5.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1538135	100.0%

Most frequent character per category

Value	Count	Frequency (%)
O	272342	17.7%
E	270720	17.6%
T	181291	11.8%
S	181291	11.8%
C	180480	11.7%
M	91051	5.9%
L	90240	5.9%
R	90240	5.9%
D	90240	5.9%
I	90240	5.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1538135	100.0%

Most frequent character per script

Value	Count	Frequency (%)
O	272342	17.7%
E	270720	17.6%
T	181291	11.8%
S	181291	11.8%
C	180480	11.7%
M	91051	5.9%
L	90240	5.9%
R	90240	5.9%
D	90240	5.9%
I	90240	5.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1538135	100.0%

Most frequent character per block

Value	Count	Frequency (%)
O	272342	17.7%
E	270720	17.6%
T	181291	11.8%
S	181291	11.8%
C	180480	11.7%
M	91051	5.9%
L	90240	5.9%
R	90240	5.9%
D	90240	5.9%
I	90240	5.9%

periodo_credito
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	711.5 KiB

MENSUAL(ES)	73389
DIARIA(S)	16635
SEMANAL(ES)	775
QUINCENAL(ES)	252

Length

Max length	13
Median length	11
Mean length	10.64013575
Min length	9

Characters and Unicode

Total characters	968795
Distinct characters	14
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MENSUAL(ES)
2nd row	MENSUAL(ES)
3rd row	MENSUAL(ES)
4th row	MENSUAL(ES)
5th row	MENSUAL(ES)

Value	Count	Frequency (%)
MENSUAL(ES)	73389	80.6%
DIARIA(S)	16635	18.3%
SEMANAL(ES)	775	0.9%
QUINCENAL(ES)	252	0.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
mensual(es	73389	80.6%
diaria(s	16635	18.3%
semanal(es	775	0.9%
quincenal(es	252	0.3%

Most occurring characters

Value	Count	Frequency (%)
S	165215	17.1%
E	148832	15.4%
A	108461	11.2%
(	91051	9.4%
)	91051	9.4%
N	74668	7.7%
L	74416	7.7%
M	74164	7.7%
U	73641	7.6%
I	33522	3.5%
Other values (4)	33774	3.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	786693	81.2%
Open Punctuation	91051	9.4%
Close Punctuation	91051	9.4%

Most frequent character per category

Value	Count	Frequency (%)
S	165215	21.0%
E	148832	18.9%
A	108461	13.8%
N	74668	9.5%
L	74416	9.5%
M	74164	9.4%
U	73641	9.4%
I	33522	4.3%
D	16635	2.1%
R	16635	2.1%
Other values (2)	504	0.1%

Value	Count	Frequency (%)
(	91051	100.0%

Value	Count	Frequency (%)
)	91051	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	786693	81.2%
Common	182102	18.8%

Most frequent character per script

Value	Count	Frequency (%)
S	165215	21.0%
E	148832	18.9%
A	108461	13.8%
N	74668	9.5%
L	74416	9.5%
M	74164	9.4%
U	73641	9.4%
I	33522	4.3%
D	16635	2.1%
R	16635	2.1%
Other values (2)	504	0.1%

Value	Count	Frequency (%)
(	91051	50.0%
)	91051	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	968795	100.0%

Most frequent character per block

Value	Count	Frequency (%)
S	165215	17.1%
E	148832	15.4%
A	108461	11.2%
(	91051	9.4%
)	91051	9.4%
N	74668	7.7%
L	74416	7.7%
M	74164	7.7%
U	73641	7.6%
I	33522	3.5%
Other values (4)	33774	3.5%

cuotas
Real number (ℝ_≥0)

Distinct	320
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.93415778

Minimum	0
Maximum	959
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	711.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	3
Q3	9
95-th percentile	15
Maximum	959
Range	959
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	23.3819336
Coefficient of variation (CV)	2.946996298
Kurtosis	212.8928241
Mean	7.93415778
Median Absolute Deviation (MAD)	2
Skewness	11.09347136
Sum	722413
Variance	546.7148191
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	40621	44.6%
10	8973	9.9%
5	8546	9.4%
3	4197	4.6%
2	4157	4.6%
12	3881	4.3%
6	3654	4.0%
4	2897	3.2%
14	2400	2.6%
9	2365	2.6%
Other values (310)	9360	10.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	40621	44.6%
2	4157	4.6%
3	4197	4.6%
4	2897	3.2%

Value	Count	Frequency (%)
959	1	< 0.1%
920	2	< 0.1%
909	1	< 0.1%
801	1	< 0.1%
546	1	< 0.1%

forma_pago
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	711.5 KiB

CRÉDITO	69063
CONTADO	19524
LIBRANZA	2464

Length

Max length	8
Median length	7
Mean length	7.027061757
Min length	7

Characters and Unicode

Total characters	639821
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	LIBRANZA
2nd row	LIBRANZA
3rd row	LIBRANZA
4th row	CRÉDITO
5th row	CRÉDITO

Value	Count	Frequency (%)
CRÉDITO	69063	75.9%
CONTADO	19524	21.4%
LIBRANZA	2464	2.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
crédito	69063	75.9%
contado	19524	21.4%
libranza	2464	2.7%

Most occurring characters

Value	Count	Frequency (%)
O	108111	16.9%
C	88587	13.8%
D	88587	13.8%
T	88587	13.8%
I	71527	11.2%
R	71527	11.2%
É	69063	10.8%
A	24452	3.8%
N	21988	3.4%
L	2464	0.4%
Other values (2)	4928	0.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	639821	100.0%

Most frequent character per category

Value	Count	Frequency (%)
O	108111	16.9%
C	88587	13.8%
D	88587	13.8%
T	88587	13.8%
I	71527	11.2%
R	71527	11.2%
É	69063	10.8%
A	24452	3.8%
N	21988	3.4%
L	2464	0.4%
Other values (2)	4928	0.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	639821	100.0%

Most frequent character per script

Value	Count	Frequency (%)
O	108111	16.9%
C	88587	13.8%
D	88587	13.8%
T	88587	13.8%
I	71527	11.2%
R	71527	11.2%
É	69063	10.8%
A	24452	3.8%
N	21988	3.4%
L	2464	0.4%
Other values (2)	4928	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	570758	89.2%
None	69063	10.8%

Most frequent character per block

Value	Count	Frequency (%)
O	108111	18.9%
C	88587	15.5%
D	88587	15.5%
T	88587	15.5%
I	71527	12.5%
R	71527	12.5%
A	24452	4.3%
N	21988	3.9%
L	2464	0.4%
B	2464	0.4%

Value	Count	Frequency (%)
É	69063	100.0%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Row	tipo_identificacion	genero	estado_civil	edad	municipio_residencia	tipo_persona	empresa	municipio_nacimiento	municipio_expedicion	tiene_casa_propia	cargo	sueldo	tiempo_servicio	otros_ingresos_mensual	otros_ingresos_concepto	municipio_credito	codeudor	entidad	sector	año_credito	mes_credito	valor_credito	estado_final	tipo_venta	periodo_credito	cuotas	forma_pago
0	1	Cedula de Ciudadania	Femenino	Soltero	47	ARAUCA	Natural	ALCALDIA DE ARAUCA	ARAUCA	ARAUCA	Si	PROFESIONAL DE APOYO	908526	21 AÑOS	NaN	NaN	ARAUCA	SIN CODEUDOR	ALCALDIA DE ARAUCA	PUBLICO	2008	12	205000	PAGADO VENCIDO	ELECTRODOMESTICOS	MENSUAL(ES)	1	LIBRANZA
1	2	Cedula de Ciudadania	Femenino	Union Libre	66	ARAUCA	Natural	ALCALDIA DE ARAUCA	ARAUCA	ARAUCA	No	INSPECTORA DE POLICIA	5500000	25 AÑOS	NaN	NaN	ARAUCA	SIN CODEUDOR	ALCALDIA DE ARAUCA	PUBLICO	2009	2	143000	PAGADO VENCIDO	ELECTRODOMESTICOS	MENSUAL(ES)	1	LIBRANZA
2	3	Cedula de Ciudadania	Femenino	Union Libre	66	ARAUCA	Natural	ALCALDIA DE ARAUCA	ARAUCA	ARAUCA	No	INSPECTORA DE POLICIA	5500000	25 AÑOS	NaN	NaN	ARAUCA	SIN CODEUDOR	ALCALDIA DE ARAUCA	PUBLICO	2009	6	680000	PAGADO VENCIDO	ELECTRODOMESTICOS	MENSUAL(ES)	7	LIBRANZA
3	4	Cedula de Ciudadania	Femenino	Casado	49	ARAUCA	Natural	ALCALDIA DE ARAUCA	ARAUCA	ARAUCA	Si	PROFESIONAL UNIVERSITARIA	4875000	23 AÑOS	4200000.0	GANADERIA	ARAUCA	SIN CODEUDOR	ALCALDIA DE ARAUCA	PUBLICO	2009	9	611000	PAGADO VENCIDO	ELECTRODOMESTICOS	MENSUAL(ES)	4	CRÉDITO
4	5	Cedula de Ciudadania	Femenino	Soltero	47	ARAUCA	Natural	ALCALDIA DE ARAUCA	ARAUCA	ARAUCA	Si	PROFESIONAL DE APOYO	908526	21 AÑOS	NaN	NaN	ARAUCA	SIN CODEUDOR	ALCALDIA DE ARAUCA	PUBLICO	2009	10	1755000	PAGADO VENCIDO	ELECTRODOMESTICOS	MENSUAL(ES)	12	CRÉDITO
5	6	Cedula de Ciudadania	Femenino	Union Libre	66	ARAUCA	Natural	ALCALDIA DE ARAUCA	ARAUCA	ARAUCA	No	INSPECTORA DE POLICIA	5500000	25 AÑOS	NaN	NaN	ARAUCA	SIN CODEUDOR	ALCALDIA DE ARAUCA	PUBLICO	2009	11	2250000	PAGADO VENCIDO	ELECTRODOMESTICOS	MENSUAL(ES)	14	CRÉDITO
6	7	Cedula de Ciudadania	Femenino	Casado	49	ARAUCA	Natural	ALCALDIA DE ARAUCA	ARAUCA	ARAUCA	Si	ALMACENISTA	3200000	31 AÑOS	0.0	NaN	ARAUCA	SIN CODEUDOR	ALCALDIA DE ARAUCA	PUBLICO	2009	11	2760000	PAGADO VENCIDO	ELECTRODOMESTICOS	MENSUAL(ES)	9	CRÉDITO
7	8	Cedula de Ciudadania	Femenino	Soltero	49	ARAUCA	Natural	ALCALDIA DE ARAUCA	ARAUCA	ARAUCA	Si	PROFESIONAL UNIVERSITARIO	4200000	20 AÑOS	0.0	NaN	ARAUCA	SIN CODEUDOR	ALCALDIA DE ARAUCA	PUBLICO	2009	11	2955000	PAGADO VENCIDO	ELECTRODOMESTICOS	MENSUAL(ES)	14	CRÉDITO
8	9	Cedula de Ciudadania	Femenino	Soltero	59	ARAUCA	Natural	ALCALDIA DE ARAUCA	ARAUCA	ARAUCA	No	OFICINA INCLUSION SOCIAL	2000000	30 AÑOS	NaN	NaN	ARAUCA	SIN CODEUDOR	ALCALDIA DE ARAUCA	PUBLICO	2009	11	1932000	DESCUENTO EN VENTA	ELECTRODOMESTICOS	MENSUAL(ES)	11	CRÉDITO
9	10	Cedula de Ciudadania	Femenino	Union Libre	48	ARAUCA	Natural	ALCALDIA DE ARAUCA	ARAUCA	ARAUCA	No	SECRETARIA	2500000	10 AÑOS	0.0	NaN	ARAUCA	SIN CODEUDOR	ALCALDIA DE ARAUCA	PUBLICO	2008	2	260000	PAGADO ANTICIPADO	ELECTRODOMESTICOS	MENSUAL(ES)	4	LIBRANZA

Last rows

	Row	tipo_identificacion	genero	estado_civil	edad	municipio_residencia	tipo_persona	empresa	municipio_nacimiento	municipio_expedicion	tiene_casa_propia	cargo	sueldo	tiempo_servicio	otros_ingresos_mensual	otros_ingresos_concepto	municipio_credito	codeudor	entidad	sector	año_credito	mes_credito	valor_credito	estado_final	tipo_venta	periodo_credito	cuotas	forma_pago
91041	91042	Cedula de Ciudadania	Masculino	Casado	37	ARAUQUITA	Natural	AUTOSERVICIO BLESSED	ARAUQUITA	ARAUQUITA	Si	PROPIETARIO	5000000	3 AÑOS	NaN	NaN	ARAUQUITA	SIN CODEUDOR	INDEP. ARAUQUITA	PRIVADO	2015	9	1740000	PAGADO ANTICIPADO	ELECTRODOMESTICOS	MENSUAL(ES)	3	CRÉDITO
91042	91043	Cedula de Ciudadania	Masculino	Union Libre	54	ARAUQUITA	Natural	SEAD ARAUCA	ARAUQUITA	ARAUQUITA	Si	RECTOR	4000000	NaN	NaN	NaN	ARAUQUITA	SIN CODEUDOR	INDEP. ARAUQUITA	PRIVADO	2015	9	430000	PAGADO ANTICIPADO	ELECTRODOMESTICOS	MENSUAL(ES)	3	CRÉDITO
91043	91044	Cedula de Ciudadania	Masculino	Union Libre	34	ARAUQUITA	Natural	INDEPENDIENTE	ARAUQUITA	ARAUQUITA	Si	PROPIETARIO	1000000	8 AÑOS	NaN	NaN	ARAUQUITA	SIN CODEUDOR	INDEP. ARAUQUITA	PRIVADO	2015	9	1600000	PAGADO ANTICIPADO	ELECTRODOMESTICOS	MENSUAL(ES)	10	CRÉDITO
91044	91045	Cedula de Ciudadania	Masculino	Union Libre	32	ARAUQUITA	Natural	INDEPENDIENTE	ARAUQUITA	ARAUQUITA	Si	MOTOTAXISTA	1500000	2 AÑOS	0.0	0	ARAUQUITA	SIN CODEUDOR	INDEP. ARAUQUITA	PRIVADO	2015	9	125000	PAGADO ANTICIPADO	ELECTRODOMESTICOS	MENSUAL(ES)	1	CRÉDITO
91045	91046	Cedula de Ciudadania	Masculino	Soltero	44	ARAUQUITA	Natural	HOSPITAL	ARAUQUITA	ARAUQUITA	Si	ASISTENCIA ADMINISTRATIVO	1300000	9 AÑOS	NaN	NaN	ARAUQUITA	CON CODEUDOR	INDEP. ARAUQUITA	PRIVADO	2015	9	800000	PAGADO VENCIDO	ELECTRODOMESTICOS	MENSUAL(ES)	8	CRÉDITO
91046	91047	Cedula de Ciudadania	Masculino	Union Libre	59	ARAUQUITA	Natural	ALCALDIA DE ARAUQUITA	ARAUQUITA	ARAUQUITA	Si	CONDUCTOR SERVICIOS PUBLICOS	2200000	28 AÑOS	NaN	NaN	ARAUQUITA	SIN CODEUDOR	INDEP. ARAUQUITA	PRIVADO	2015	9	868000	PAGADO ANTICIPADO	ELECTRODOMESTICOS	MENSUAL(ES)	3	CRÉDITO
91047	91048	Cedula de Ciudadania	Masculino	Casado	47	ARAUQUITA	Natural	INDEPENDIENTE	ARAUQUITA	ARAUQUITA	Si	ADMINISTRADOR FINCA	800000	7 AÑOS	NaN	NaN	ARAUQUITA	SIN CODEUDOR	INDEP. ARAUQUITA	PRIVADO	2015	8	1350000	PAGADO ANTICIPADO	ELECTRODOMESTICOS	MENSUAL(ES)	10	CRÉDITO
91048	91049	Cedula de Ciudadania	Masculino	Casado	37	ARAUQUITA	Natural	INDEPENDIENTE	ARAUQUITA	ARAUQUITA	Si	COMERCIANTE	1000000	20 AÑOS	NaN	NaN	ARAUQUITA	SIN CODEUDOR	INDEP. ARAUQUITA	PRIVADO	2015	9	980000	PAGADO VENCIDO	ELECTRODOMESTICOS	MENSUAL(ES)	6	CRÉDITO
91049	91050	Cedula de Ciudadania	Masculino	Union Libre	34	ARAUQUITA	Natural	INDEPENDIENTE	ARAUQUITA	ARAUQUITA	Si	COMERCIANTE	1000000	2 AÑOS	NaN	NaN	ARAUQUITA	SIN CODEUDOR	INDEP. ARAUQUITA	PRIVADO	2015	9	1050000	PAGADO ANTICIPADO	ELECTRODOMESTICOS	MENSUAL(ES)	2	CRÉDITO
91050	91051	Cedula de Ciudadania	Masculino	Union Libre	31	ARAUQUITA	Natural	RYR SOLUCIONES	ARAUQUITA	ARAUQUITA	Si	TECNICO ELECTRICISTA	1500000	3 AÑOS	NaN	NaN	ARAUQUITA	SIN CODEUDOR	INDEP. ARAUQUITA	PRIVADO	2015	9	838000	PAGADO ANTICIPADO	ELECTRODOMESTICOS	MENSUAL(ES)	3	CRÉDITO

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters